Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/POP10500
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: Purchasing Receipt Line Quantities Group Display Name: Purchasing Transactions
Physical Name: POP10500
Technical Name: POP_PORcptApply
Group Technical Name: Purchasing Transactions
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | PONUMBER  | PO Number | String | STR17_POP_Number | 17 | |
| 2 | POLNENUM | PO Line Number | Long Integer | LI_Sequence_Number | 10 | |
| 3 | POPRCTNM | POP Receipt Number | String | STR17_POP_Number | 17 | |
| 4 | RCPTLNNM | Receipt Line Number | Long Integer | LI_Sequence_Number | 10 | |
| 5 | QTYSHPPD | QTY Shipped | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 6 | QTYINVCD | QTY Invoiced | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 7 | QTYREJ | QTY Rejected | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 8 | QTYMATCH | QTY Matched | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 9 | QTYRESERVED | QTY Reserved | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 10 | QTYINVRESERVE | QTY Invoice Reserve | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 11 | Status | Status | Integer | INT | 0 | |
| 12 | UMQTYINB | U Of M QTY In Base | Currency | DLR17_QTY_RBS0_STR | 17 | |
| The quantity of the base unit of measure that is equivalent to one of the units of measure being referenced. | ||||||
| 13 | OLDCUCST | Old Current Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 14 | JOBNUMBR | Job Number | String | STR17_LBAU | 17 | |
| 15 | COSTCODE | Cost Code | String | STR27 | 27 | |
| 16 | COSTTYPE | Cost Code Type | Integer | INT3_RB0_U | 3 | |
| 17 | ORCPTCOST | Originating Receipt Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 18 | OSTDCOST | Originating Standard Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 19 | APPYTYPE | Apply Type | Integer | INT | 0 | |
| 20 | POPTYPE | POP Type | Integer | DDL_POP_Type | 0 | |
| 21 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['Purchasing Receipt Line Quantities'].VENDORID AS 'Purchasing Receipt Line Quantities-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Purchasing Receipt Line Quantities'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
| 22 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['Purchasing Receipt Line Quantities'].ITEMNMBR AS 'Purchasing Receipt Line Quantities-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Purchasing Receipt Line Quantities'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
| 23 | UOFM | U Of M | String | U_Of_M | 8 | |
| The unit of measure. The value in this field must exist in Inventory. | ||||||
| 24 | TRXLOCTN | TRX Location | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['Purchasing Receipt Line Quantities'].TRXLOCTN AS 'Purchasing Receipt Line Quantities-TRX Location'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Purchasing Receipt Line Quantities'].TRXLOCTN = ['Site Setup'].LOCNCODE | ||||||
| 25 | DATERECD | Date Received | Date | DATE | 6 | |
| 26 | RCTSEQNM | Receipt SEQ Number | Long Integer | long | 8 | |
| 27 | SPRCTSEQ | Split Receipt SEQ Number | Long Integer | long | 8 | |
| 28 | PCHRPTCT | Purchase Receipt Cost | Currency | DLR17_RBSO_UTR$ | 17 | |
| 29 | SPRCPTCT | Split Receipt Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 30 | OREXTCST | Originating Extended Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 31 | RUPPVAMT | Remaining UPPV Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 32 | ACPURIDX | Accrued Purchases Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['Purchasing Receipt Line Quantities'].ACPURIDX AS 'Purchasing Receipt Line Quantities-Accrued Purchases Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Purchasing Receipt Line Quantities'].ACPURIDX = ['Account Index Master'].ACTINDX | ||||||
| 33 | INVINDX | Inventory Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['Purchasing Receipt Line Quantities'].INVINDX AS 'Purchasing Receipt Line Quantities-Inventory Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Purchasing Receipt Line Quantities'].INVINDX = ['Account Index Master'].ACTINDX | ||||||
| 34 | UPPVIDX | Unrealized Purchase Price Variance Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['Purchasing Receipt Line Quantities'].UPPVIDX AS 'Purchasing Receipt Line Quantities-Unrealized Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Purchasing Receipt Line Quantities'].UPPVIDX = ['Account Index Master'].ACTINDX | ||||||
| 35 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['Purchasing Receipt Line Quantities'].NOTEINDX AS 'Purchasing Receipt Line Quantities-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Purchasing Receipt Line Quantities'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
| 36 | CURNCYID | Currency ID | String | STR15_Currency_ID | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['Purchasing Receipt Line Quantities'].CURNCYID AS 'Purchasing Receipt Line Quantities-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Purchasing Receipt Line Quantities'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
| 37 | CURRNIDX | Currency Index | Integer | INT3 | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['Purchasing Receipt Line Quantities'].CURRNIDX AS 'Purchasing Receipt Line Quantities-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Purchasing Receipt Line Quantities'].CURRNIDX = ['Currency Setup'].CURRNIDX | ||||||
| 38 | XCHGRATE | Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 39 | RATECALC | Rate Calc Method | Integer | INT | 0 | |
Rate Calc Method of the transaction. For non multi-currency transactions, this field will be blank.
Click to show/hide Rate Calc Methods0 Multiply
1 Divide | ||||||
| 40 | DENXRATE | Denomination Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 41 | RATETPID | Rate Type ID | String | STR15_Rate_Type_ID | 15 | |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['Purchasing Receipt Line Quantities'].RATETPID AS 'Purchasing Receipt Line Quantities-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['Purchasing Receipt Line Quantities'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID | ||||||
| 42 | EXGTBLID | Exchange Table ID | String | STR15_Exchange_Table_ID | 15 | |
Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hideSELECT
['Purchasing Receipt Line Quantities'].EXGTBLID AS 'Purchasing Receipt Line Quantities-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
POP10500 AS ['Purchasing Receipt Line Quantities']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['Purchasing Receipt Line Quantities'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID | ||||||
| 43 | Capital_Item | Capital Item | Boolean | CB_Capital_Item | 0 | |
| 44 | Product_Indicator | Product Indicator | Integer | DDL_Product_Indicator | 0 | |
| 45 | Total_Landed_Cost_Amount | Total Landed Cost Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 46 | QTYTYPE | QTY Type | Integer | DDL_QTY_Type | 0 | |
| 47 | Posted_LC_PPV_Amount | Posted LC PPV Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 48 | QTYREPLACED | QTY Replaced | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 49 | QTYINVADJ | QTY Invoice Adjustment | Currency | DLR17_QTY_RBS0_UTR | 17 | |